<?php
	$activo = 1;
	$dir = pathinfo($_SERVER['SCRIPT_FILENAME']); 

	if (ini_set("include_path",ini_get("include_path").((strtoupper(PHP_OS) == "LINUX") ? ":" : ";").$dir['dirname']) === false) {
		echo "ERROR: Definicion en el include_path";
		exit;
	}

	include('../adodb/adodb.inc.php');
	include_once('../adodb/adodb-pager.inc.php');
    include_once('../conf/dbconn_param.php');
	
	
	$db = ADONewConnection($dbdriver);
	$db->Connect($server, $user, $password, $database);
	$db->SetFetchMode(ADODB_FETCH_ASSOC);

    $db->debug = false;
	
	$sql = "select * from finca order by nombre";
	
	
    $rs = $db->Execute($sql);
    $datos = $rs->GetRows();
	
	echo '{'; 
	
	$i = 0;
	foreach($datos as $data_) {	
	     if ($i++) echo ',';
         echo "'".$data_['finca_id']."':'".utf8_encode($data_['nombre'])."'";
    }
	
	echo '}'; 
	 $db->Close();
?>	